USE OldStuffShopping
GO

------------------------------------------------
-- Description: Initial data for [UserAccount] --
------------------------------------------------
INSERT INTO [UserAccount]
	([FirstName], [LastName], [Email], [Password])
VALUES
	('Hai', 'Luong Quang', 'luongquanghai@gmail.com', '123456'),
	('Duy', 'Tran Quang', 'tranquangduy@gmail.com', '123456'),
	('Hung', 'Ta Duy', 'taduyhung@gmail.com', '123456'),
	('Dat', 'Dang Huy', 'danghuydat@gmail.com', '123456')
-- SELECT * FROM [UserAccount]

---------------------------------------------
-- Description: Initial data for [Category] --
---------------------------------------------
------------ Parent ------------------------
INSERT INTO Category ([Name])
VALUES 
	('Electronics'),
	('Computers & accessories'),
	('Transportations'),
	('Furnitures'),
	('Fashion stuffs'),
	('Daily using stuffs')

---------------Child-----------------------
--INSERT INTO Category([Name], [ParentId])
--VALUES 
--	('Phones', 1),
--	('Cameras', 1),
--	('Refrigerators', 1),
--	('Televisions', 1),
--	('Players', 1),
--	('Other Electronics', 1),
--	('Computers', 2),
--	('Laptops', 2),
--	('Accessories', 2),
--	('Cars', 3),
--	('Bicycles', 3),
--	('Motors', 3),
--	('Other transportations', 3),
--	('Kitchen furnitures', 4),
--	('Bedroom furnitures', 4),
--	('Bathroom furnitures', 4),
--	('Living room furnitures', 4),
--	('Other furnitures', 4),
--	('Clothing', 5),
--	('Shoes', 5),
--	('Belts', 5),
--	('Watches', 5),
--	('Glasses', 5),
--	('Bracelets', 5),
--	('Necklaces', 5),
--	('Rings', 5),
--	('Bags', 5),
--	('Wallets', 5),
--	('Other fashion stuffs', 5),
--	('Shampoos', 6),
--	('Shower gel', 6),
--	('Soaps', 6),
--	('Makeups', 6),
--	('Cleansers', 6),
--	('Other daily using stuffs', 6)
-- SELECT * FROM [Category]


INSERT INTO UserStuff
	([UserId],[CategoryId],[Name],[Quantity],[Description],[UnitPrice])
VALUES
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),1,'iPhone 4',1,'= new 99%, 8GB Selling',350),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),1,'iPhone 4s',1,'Old but in good condition 80% Selling',400),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),1,'Nokia 1280',1,'Brand new Selling or exchanging',25),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),1,'Canon EOS 60D',1,'= new 99%,18 - 135 mm, F 3.5 - 5.6 IS UD Selling or Exchanging',800),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),1,'Refrigerator made in china',1,'= new 99% Selling or Exchanging',150),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),1,'TV Sony',1,'80% Selling or Exchanging',245),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),1,'iPod touch GEN 5',1,'Used for 2 months Selling, , 64 GB, Full of payed games',250),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),2,'Computer',1,'Used almost 2 years, Chip dual cores 2,5 Hz, RAM 2GB, 64GB, VGA Family chipset Selling',75),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),2,'DELL VOSTRO 1450',1,'Chip core i7, RAM 8GB, 500GB, HP 4000 Selling or Exchanging',700),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),2,'RAM',5,'DDR 2 2GB brand new Selling',13),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),2,'USB',2,'8GB brand new Selling',10),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),3,'Ford focus 1.8 - 2007',1,'Used 1.5 years Selling or Exchanging',13000),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),3,'Mountain Bike',1,'brand new Selling',300),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),4,'WAVE RSX Honda',1,'110cc, 80% Selling',750),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),4,'Sofa',1,'1 coach brand new Selling',500),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),5,'Korea Cool T-Shirts',10,'brand new, make you look = Korea stars Selling',20),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),5,'England Classical Shoes',1,'brand new Selling',1000),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),5,'Casino watch',1,'Brand new, very nice Selling',1400),
	((SELECT Id FROM UserAccount WHERE Email = 'danghuydat@gmail.com'),6,'American shampoo',8,'Best choice for men Selling',35)
-- SELECT * FROM [UserStuff]
-- SELECT * FROM [Order]